
--
-- Insert dummy test data
--

USE `accommodation`;

BEGIN;

INSERT INTO `universities`(`name`)
VALUES('Universitatea Politehnica Bucuresti');

INSERT INTO `colleges`(`university_id`, `name`)
VALUES
(LAST_INSERT_ID(), 'Automatica si Calculatoare'),
(LAST_INSERT_ID(), 'Electronica, Telecomunicatii si Tehnologia Informatiei'),
(LAST_INSERT_ID(), 'Stiinte Aplicate'),
(LAST_INSERT_ID(), 'Energetica'),
(LAST_INSERT_ID(), 'Inginerie Electrica'),
(LAST_INSERT_ID(), 'Ingineriei Mecanica si Mecatronica'),
(LAST_INSERT_ID(), 'Ingineria si Managementul Sistemelor Tehnologice'),
(LAST_INSERT_ID(), 'Ingineria Sistemelor Biotehnice'),
(LAST_INSERT_ID(), 'Transporturi'),
(LAST_INSERT_ID(), 'Inginerie Aerospatiala');

INSERT INTO `universities`(`name`)
VALUES('Universitatea Bucuresti');

INSERT INTO `colleges` (`university_id`, `name`)
VALUES
(LAST_INSERT_ID(), 'Drept'),
(LAST_INSERT_ID(), 'Matematica Informatica'),
(LAST_INSERT_ID(), 'Geografie'),
(LAST_INSERT_ID(), 'Limbi straine');

INSERT INTO `universities`(`name`)
VALUES('Universitatea Spiru Haret');

INSERT INTO `colleges` (`university_id`, `name`)
VALUES
(LAST_INSERT_ID(), 'Arhitectura'),
(LAST_INSERT_ID(), 'Matematica Informatica'),
(LAST_INSERT_ID(), 'Filozofie'),
(LAST_INSERT_ID(), 'Finante Banci'),
(LAST_INSERT_ID(), 'Management Financiar Contabil');

INSERT INTO `students`( `college_id`, `first_name`, 
`last_name`, `cnp`, `email`, `password`)
VALUES
( 1, 'Ion', 'Popescu', '1112002033389', 'ion@yahoo.com', MD5('ion')),
( 1, 'Andrei', 'Savu', '1871002033389', 'savu.andrei@yahoo.com', MD5('asd'));

INSERT INTO `places`(`name`, `rooms`, `places_per_room` ) VALUES
('P1', '10', '4'),
('P2', '100', '4'),
('P3', '10', '4'),
('P4', '100', '2'),
('P5', '200', '4'),
('P6', '300', '2'),
('P7', '200', '4'),
('P8', '200', '2'),
('P9', '200', '4'),
('P10', '200', '4'),
('P11', '200', '2'),
('P12', '200', '4');

COMMIT;
